
clear
set more off
cd "/Users/michaelflynn/Dropbox/Projects/Aid and NGOs/Data"
use "ngoaiddata.dta", clear


label var exports_percent "Exports as % of Donor GDP"
label var gov_export "Ideology $\times$ Exports"
label var gov_un "Ideology $\times$ UN Affinity"
label var gov_defense "Ideology $\times$ Alliance"
label var gov_hr "Ideology $\times$ Physical Integrity Rights"
label var gov_develop "Ideology $\times$ GDP Per Capita"
label var gov_export2 "Ideology $\times$ Exports"
label var gov_un2 "Ideology $\times$ UN Affinity"
label var gov_defense2 "Ideology $\times$ Alliance"
label var gov_hr2 "Ideology $\times$ Physical Integrity Rights"
label var logexport "ln(Exports)"
label var gov_develop2 "Ideology $\times$ GDP Per Capita"
label var percright "Percentage of Right Parties"
label var post08 "Post-Financial Crisis"
label var growth "Donor Growth Rate"
label var polity2 "Recipient Polity Score"
label var physint "Recipient Physical Integrity Rights"
label var logtrade "ln(Trade)"
label var lndisasternum2l "Natural Disasters"
label var defense "Alliance"
label var s3un "UN Affinity"
label var lnall "ln(All Aid Channels)"
label var govtrile "Donor Government Ideology Score"
label var govtecon "Donor Government Ideology Score"
label var lnratio "ln(Aid Ratio)"
label var prio2 "Recipient Civil Conflict"
label var lnngo "ln(NGO Aid)"
label var lnpublic "ln(Public Aid)"
label var loggdppc "Recipient GDP Per Capita"
label var governance_all_mean "Recipient Governance"

set matsize 2000
drop if dyad==.
xtset dyad year

* Summary Statistics
reg F.lnratio govtecon socgdp1Ml growth s3un defense physint polity2 loggdppc governance_all_mean prio2 lnall  colony lnratio, robust
sutex2 lnratio govtecon socgdp1Ml growth s3un defense exports_percent colony polity2 loggdppc governance_all_mean prio2 physint if e(sample) , ///
digits(3) minmax varlab tabular ///
caption("Summary Statistics") tablabel(tab:sumstat) saving(table_sumstats) placement("t") replace
